package model.agent.mapper;

import model.agent.entity.Agent;
import model.agent.entity.Newhouse;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2019/6/30.
 */
@Mapper
public interface CollectMapper {
    //根据id查找经纪人
    @Select("select * from collect join agent on collect.agentid=agent.id where collect.id=#{id}")
    List<Agent> getById(String id);
    @Select("select * from collect join newhouse on collect.newhouseid=newhouse.newhouse_id where collect.id=#{id}")
    List<Newhouse> getId(String id);
}
